SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Located just a half mile south of the Dartmouth Green, this beautifully updated raised ranch offers the perfect blend of comfort, flexibility, and convenience. Tucked on a level, landscaped lot with lawn space and landscaping, the home provides an easy lifestyle in a truly exceptional location, walkable to downtown, schools, dining, and recreation. The thoughtfully designed main level features three bedrooms--one ensuite with a 3/4 bath and two that share an additional full bath. Sunlight fills the welcoming living room, while the adjoining dining area opens seamlessly onto a deck - ideal for morning coffee or summer BBQs. The updated kitchen offers both style and functionality, creating a warm central gathering space for everyday living. The finished lower level adds remarkable versatility, with a large family room centered around a cozy wood stove, perfect for relaxing evenings or casual entertaining. A full bath, laundry room, dedicated office, and smaller bonus room provide flexible spaces to work, create, or host guests with ease. Direct access to the attached one-car garage adds everyday convenience, especially during New England winters. With recent updates, abundant usable space, and an unbeatable in-town setting, this move-in-ready home offers the rare opportunity to enjoy comfort, character, and walkability in the heart of Hanover. Furnished photos are virtually staged.
Description:This beautifully renovated 3-bedroom, 3-bath split-level home offers the perfect blend of modern updates and an unbeatable Hanover location. Thoughtfully redesigned from top to bottom, the property features all-new siding, roof, windows, central air conditioning, and stylishly updated kitchen and baths. Bright, comfortable living spaces and a versatile floor plan make everyday living and entertaining effortless. Set in a sought-after neighborhood within easy walking distance to the highly acclaimed Hanover elementary and middle schools, this turnkey home combines quality, convenience, and timeless appeal.
Description:This waterfront gem has been thoughtfully enhanced with numerous recent improvements, including a newly winterized sunroom that adds 264 square feet of light-filled living space with sweeping water views. The updated exterior façade, new privacy fencing, and improved stairway leading to the private sandy beach and swimming area further elevate the property’s appeal. Offering ~3,000 sq ft across three levels, this home features 2 bedrooms plus a bonus room, 3½ baths, and flexible living areas. Enter through the generous mudroom into an open-concept kitchen, dining, and living area designed for both everyday comfort and effortless entertaining. This inviting space flows seamlessly into the newly heated, insulated sunroom perched above the water’s edge, where panoramic lake views can be enjoyed year-round. The lower level offers a full bath and two oversized rooms ideal for bedrooms, office, or family space, both with walkout access to the lakeside deck. The lowest level includes a partially finished area, full bath, workshop, and direct walkout waterfront access. Conveniently located near Dartmouth College, Dartmouth Hitchcock Medical Center, and premier ski resorts. This is the ideal year-round lakefront paradise.
Description:Price adjustment! This BRAND NEW home is a fresh, modern offering in Etna. This contemporary offers a composed, modern feel, combining clean lines with durable finishes. The main level is designed for connection while maintaining definition, with kitchen and dining areas that flow naturally yet feel purposeful. Vaulted ceilings and large windows bring in abundant natural light, and the finishes are current and understated, keeping the focus on space and light. Four bedrooms are thoughtfully distributed across two floors, offering flexibility for guests, work-from-home needs, or long-term living. The primary suite is comfortable and private, and the first-floor laundry adds everyday convenience. A lofted living room adds architectural interest and a sense of openness, creating a light-filled upper level that overlooks the main living space. This area connects seamlessly to an additional second-floor bedroom, providing a flexible option for guests, a studio, or a quiet retreat. The setting is peaceful, with level land that invites a range of uses while remaining easy to maintain. Outdoor space extends the living experience, offering room to garden, gather, or simply enjoy the surroundings. A detached two-car garage and generous parking area complement the home without overwhelming the site. Inside, storage is well considered, with ample closets and practical spaces that support organized, everyday living. Located just minutes from Hanover and Dartmouth, and within the Dresden School District, the property offers a compelling balance of accessibility and a more relaxed pace. Clean, modern, and thoughtfully designed, this home is well executed and ready for immediate enjoyment.
Description:Super Sunsets on Crystal Lake! This private 2006 lakefront home offers 112' of pristine waterfront with 3 bedrooms, 2 baths, cathedral ceilings, and an open-concept living area filled with natural light and stunning lake views. The finished walkout basement provides extra space for family and guests, while the full-length screened porch, lakeside deck, grassy yard, and established docks make outdoor living easy. A drilled well, storage shed, and shared ownership of 21+ wooded acres with trails across the road complete this exceptional property. Location, location, location!
Description:Looking for a property that truly has it all? Look no further than 376 Orford Road, in the coveted town of Lyme, NH. With 4,500 square feet of wonderfully comfortable and functional living space, the first floor offers a primary en suite bedroom, 2 additional bedrooms and bathrooms, a large living room, spacious eat-in kitchen, mudroom and laundry. The lower level includes a media room, recreation room, exercise room and office. Attached to the main residence, and with its own entrance as well, is a two story auxiliary dwelling unit equipped with a full eat-in kitchen, living room, laundry, 3/4 bathroom and private deck - ideal for in-laws, a nanny or rental opportunity. The back of the home connects to the level, landscaped, and fenced-in backyard area with a deck, in-ground pool, and pool house - ideal for relaxing or entertaining. The oversized 3 car garage has an upper level that could easily be finished off for additional living space, or is ideal "as is" for a home office or business storage. The abutting conserved land offers lovely pastoral views and westerly sunsets. Rounding out the property is another large outbuilding and separate shed for all your storage needs. Lyme is home to one of the most highly rated K - 8th grade schools in the state and is a short drive to Hanover, Dartmouth College and Dartmouth Health. Don't miss this incredible opportunity for a property that has everything you want, and more.
Description:Tucked away on 6.3 acres, this classic 1998 Colonial offers a rare blend of seclusion and modern comfort. Built and lovingly maintained by the original owner, the home has a spacious open floor plan, and abundant natural light through oversized windows. The heart of the home is the bright eat-in kitchen, opening to the back deck—perfect for morning coffee while watching local wildlife. Upstairs, the second floor features a generous primary suite, three additional bedrooms, and a versatile den/office. Downstairs, the large, unfinished walkout basement is a blank canvas. Whether you envision a home gym, a media room, or an expansive workshop, the possibilities are endless. Complete with an attached two-car garage, this is the perfect place to call home.
Description:A luxurious waterfront property in Eastman located at the end of a cul-de-sac offering the utmost privacy and seclusion. This home boasts an exceptional location with stunning views of Eastman Lake from its elevated position. The design of the house takes full advantage of the scenic surroundings, featuring walls of glass with all new sliders that open up to a spacious deck, creating a seamless indoor-outdoor living experience. The interior is thoughtfully designed with an inviting floor plan. It includes a bedroom suite with a generously sized bathroom, a great room, and family room, all adorned with cozy fireplaces. The three bedrooms in the home offer breathtaking views and can be enjoyed in all seasons. Living in the Eastman Community provides an opportunity to embrace an outdoor lifestyle, taking advantage of the surroundings and the proximity to walking trails and the lake. Enjoy tennis, pickleball, golf, XC ski trails, an indoor pool, fitness center and more. Whether it's watching the sunset from the comfort of your home or indulging in various outdoor activities, this residence offers a remarkable waterfront living experience.
Description:Experience year-round recreation and lakefront living at this stunning log home on the shores of Crystal Lake. Built in 2014 and set on a level .74-acre lot with 401 feet of private waterfront, this exceptional property offers the perfect blend of rustic elegance, comfort lake living with unforgettable outdoor enjoyment. The spacious main level features a desirable first-floor primary suite with a private bath, creating an ideal retreat after a day on the water. Upstairs, you’ll find an additional bedroom, a dedicated exercise room with deck access and lake views, a stylish full bath, providing comfortable accommodations for family and guests. A detached, heated barn with a half bath offers outstanding flexibility for a studio, hobbies, storage, workshop space, or recreational equipment. Whether you’re boating, swimming, snowmobiling, or simply relaxing by the water, this remarkable Crystal Lake property delivers the ultimate four-season lifestyle.
Description:NEW PRICE! - Rarely available in one of Hanover’s most coveted in-town locations, this charming Gambrel Colonial offers the perfect blend of classic 1920s character, thoughtful updates, and unbeatable convenience. Tucked on a quiet street of only four homes on the edge of downtown Hanover, 1 Ripley Road is just moments from Main Street, Dartmouth College, local shops, restaurants, cafés, and all that Hanover has to offer within walking distance. Filled with wonderful natural light due to its excellent southern exposure, the home features three bedrooms, one and a half baths, hardwood flooring throughout, and a warm, inviting layout. The cozy living room includes a wood fireplace, while the dining room off the kitchen showcases a classic 1920s built-in adding timeless charm. The sunroom/family room offers a bright and comfortable additional living space, while the walk-out basement provides laundry, generous storage, a workout area, and office space, adding valuable flexibility to the home. Recent improvements include refinished first-floor flooring in 2020, all-new sunroom windows and fully refurbished first-floor windows with a second pane of glass and new seals in 2021. In 2022, the kitchen and first-floor bathroom were beautifully redone, and all appliances were replaced, offering the ease of modern updates while preserving the home’s original character. A truly special Hanover offering, this property combines charm with modern updates, light, privacy, and a prime walk-to-town location in a way that is increasingly hard to find.